CREATE TABLE [dbo].[TCFLUJ_PROY]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[NU_ANIO] [dbo].[TD_IN_004_ANOS] NOT NULL,
[NU_SECU] [dbo].[TD_IN_001] NOT NULL CONSTRAINT [DF__TCFLUJ_PR__NU_SE__607251E5] DEFAULT ((0)),
[FE_PROY] [dbo].[TD_DT_001] NOT NULL,
[CO_MONE] [dbo].[TD_VC_003] NOT NULL,
[FA_TIPO_CAMB] [dbo].[TD_NU_015_006] NULL,
[ST_PROC] [dbo].[TD_VC_001_SINO] NOT NULL CONSTRAINT [DF__TCFLUJ_PR__ST_PR__6166761E] DEFAULT ('N'),
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TCFLUJ_PR__CO_US__634EBE90] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TCFLUJ_PR__FE_US__6442E2C9] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TCFLUJ_PR__CO_US__65370702] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TCFLUJ_PR__FE_US__662B2B3B] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCFLUJ_PROY] WITH NOCHECK ADD CONSTRAINT [CK__TCFLUJ_PR__NU_AN__5F7E2DAC] CHECK NOT FOR REPLICATION (([NU_ANIO]>(1980)))
GO
ALTER TABLE [dbo].[TCFLUJ_PROY] WITH NOCHECK ADD CONSTRAINT [CK__TCFLUJ_PR__ST_PR__625A9A57] CHECK NOT FOR REPLICATION (([ST_PROC]='N' OR [ST_PROC]='S'))
GO
ALTER TABLE [dbo].[TCFLUJ_PROY] ADD CONSTRAINT [PK__TCFLUJ_P__E19F5ABD17D860BF] PRIMARY KEY CLUSTERED  ([CO_EMPR], [NU_ANIO], [NU_SECU]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCFLUJ_PROY] ADD CONSTRAINT [FK__TCFLUJ_PR__CO_EM__084C046C] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
